[ROOT] dt FactResellerSale < WHERE DimResellerId EQ '7' >
16 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46613_1 | D7EC-42C8-AF | PO15602156182 | 100 | 272 | 352 | 7 | 1 | 2022-04-15 | 1242.85 | 31.07 | 2022-04-03 | 1 | 1117.86 | 1 | 1242.85 | 1 | SO46613 | 2022-04-10 | 99.43 | 1117.86 | 1242.85 |
SO47667_1 | 5C8F-41D1-9C | PO15602134650 | 100 | 282 | 412 | 7 | 1 | 2022-07-16 | 180.13 | 4.50 | 2022-07-04 | 1 | 133.30 | 1 | 180.13 | 1 | SO47667 | 2022-07-11 | 14.41 | 133.30 | 180.13 |
SO46613_2 | D7EC-42C8-AF | PO15602156182 | 100 | 272 | 289 | 7 | 1 | 2022-04-15 | 1488.55 | 37.21 | 2022-04-03 | 2 | 660.91 | 1 | 1488.55 | 2 | SO46613 | 2022-04-10 | 119.08 | 1321.83 | 744.27 |
SO47667_2 | 5C8F-41D1-9C | PO15602134650 | 100 | 282 | 358 | 7 | 1 | 2022-07-16 | 1229.46 | 30.74 | 2022-07-04 | 1 | 1105.81 | 1 | 1229.46 | 2 | SO47667 | 2022-07-11 | 98.36 | 1105.81 | 1229.46 |
SO46613_3 | D7EC-42C8-AF | PO15602156182 | 100 | 272 | 421 | 7 | 1 | 2022-04-15 | 196.33 | 4.91 | 2022-04-03 | 1 | 145.28 | 1 | 196.33 | 3 | SO46613 | 2022-04-10 | 15.71 | 145.28 | 196.33 |
SO47667_3 | 5C8F-41D1-9C | PO15602134650 | 100 | 282 | 421 | 7 | 1 | 2022-07-16 | 196.33 | 4.91 | 2022-07-04 | 1 | 145.28 | 1 | 196.33 | 3 | SO47667 | 2022-07-11 | 15.71 | 145.28 | 196.33 |
SO47667_4 | 5C8F-41D1-9C | PO15602134650 | 100 | 282 | 411 | 7 | 1 | 2022-07-16 | 376.25 | 9.41 | 2022-07-04 | 3 | 92.81 | 1 | 376.25 | 4 | SO47667 | 2022-07-11 | 30.10 | 278.42 | 125.42 |
SO47667_5 | 5C8F-41D1-9C | PO15602134650 | 100 | 282 | 464 | 7 | 1 | 2022-07-16 | 42.39 | 1.06 | 2022-07-04 | 3 | 9.71 | 1 | 42.39 | 5 | SO47667 | 2022-07-11 | 3.39 | 29.14 | 14.13 |
SO48765_1 | 6400-46C0-9E | PO15602117297 | 100 | 282 | 352 | 7 | 1 | 2022-10-16 | 1242.85 | 31.07 | 2022-10-04 | 1 | 1117.86 | 1 | 1242.85 | 1 | SO48765 | 2022-10-11 | 99.43 | 1117.86 | 1242.85 |
SO48765_2 | 6400-46C0-9E | PO15602117297 | 100 | 282 | 399 | 7 | 1 | 2022-10-16 | 33.77 | 0.84 | 2022-10-04 | 1 | 24.99 | 1 | 33.77 | 2 | SO48765 | 2022-10-11 | 2.70 | 24.99 | 33.77 |
SO48765_3 | 6400-46C0-9E | PO15602117297 | 100 | 282 | 221 | 7 | 1 | 2022-10-16 | 60.56 | 1.51 | 2022-10-04 | 3 | 13.88 | 1 | 60.56 | 3 | SO48765 | 2022-10-11 | 4.84 | 41.63 | 20.19 |
SO48765_4 | 6400-46C0-9E | PO15602117297 | 100 | 282 | 460 | 7 | 1 | 2022-10-16 | 161.98 | 4.05 | 2022-10-04 | 3 | 37.12 | 1 | 161.98 | 4 | SO48765 | 2022-10-11 | 12.96 | 111.36 | 53.99 |
SO49861_1 | C812-4BE2-8D | PO15602115974 | 100 | 282 | 412 | 7 | 1 | 2023-01-14 | 540.39 | 13.51 | 2023-01-02 | 3 | 133.30 | 1 | 540.39 | 1 | SO49861 | 2023-01-09 | 43.23 | 399.89 | 180.13 |
SO49861_2 | C812-4BE2-8D | PO15602115974 | 100 | 282 | 459 | 7 | 1 | 2023-01-14 | 53.99 | 1.35 | 2023-01-02 | 1 | 37.12 | 1 | 53.99 | 2 | SO49861 | 2023-01-09 | 4.32 | 37.12 | 53.99 |
SO49861_3 | C812-4BE2-8D | PO15602115974 | 100 | 282 | 236 | 7 | 1 | 2023-01-14 | 86.52 | 2.16 | 2023-01-02 | 3 | 29.08 | 1 | 86.52 | 3 | SO49861 | 2023-01-09 | 6.92 | 87.24 | 28.84 |
SO49861_4 | C812-4BE2-8D | PO15602115974 | 100 | 282 | 364 | 7 | 1 | 2023-01-14 | 647.99 | 16.20 | 2023-01-02 | 1 | 598.44 | 1 | 647.99 | 4 | SO49861 | 2023-01-09 | 51.84 | 598.44 | 647.99 |
Generated 2024-05-04 02:05:57.562 UTC